hpv_vaccination_cdc

Table: hpv_vaccination_cdc

The hpv_vaccination_cdc table records CDC-specific vaccination events for children in the HPV program.
It is used to track vaccination timestamps and link events to vaccination records for reporting and synchronization purposes.

---

Columns

Column Name	Data Type	Constraints	Description
id	int(11)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY, UNIQUE	Unique identifier for each CDC vaccination record
timestamp	datetime	NOT NULL	Timestamp of the CDC vaccination event entry
vaccinationRecordNum	int(11)	NOT NULL	Reference to the main vaccination record (hpv_vaccination.vaccinationRecordNum)
vaccinationDate	date	NOT NULL	Date when the vaccination occurred

---

Indexes

1. PRIMARY - Primary key on id
2. UNIQUE - id_UNIQUE on id
3. idx_vaccinationDate - Index on vaccinationDate using BTREE

---

Foreign Key Relations

• No explicit foreign key constraints are defined, but vaccinationRecordNum typically references hpv_vaccination.vaccinationRecordNum.

---

Usage Notes

• Used for CDC reporting and data synchronization.

• Tracks the exact timestamp of CDC vaccination events separate from general vaccination records.

• Indexed on vaccinationDate to support efficient querying and reporting by date.

• Ensures each record is unique via id for data integrity in CDC reporting pipelines.